SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_SearchEmailBycopy_to]

	(
	@param_Admin_LoginID VarChar(50),
	@param_copy_to VarChar(max)
	)
AS
	/* SET NOCOUNT ON */
	
	Select * from dbo.JOL_EmailManagement_Email where Admin_LoginID=@param_Admin_LoginID and copy_to like '%'+@param_copy_to+'%'	
	RETURN

GO
